package com.mvc.cms.dao.assist;

import java.util.Date;
import java.util.List;

import com.mvc.cms.entity.assist.CmsHouseData;
import com.mvc.common.page.Pagination;

public interface CmsHouseDataDao{
	
	public CmsHouseData save(CmsHouseData bean);
	
	public CmsHouseData find(Integer id);
	
	public CmsHouseData delete(Integer id);
	
	/**
	 * 按区域统计数据
	 * @param begin
	 * @param end
	 * @return
	 */
	public List<Object[]> rangeStatistics(String name,String area,String seller,
	        String license,String use,String building,Date begin,Date end);
	
	/**
	 * 按楼盘统计数据
	 * @param begin
	 * @param end
	 * @return
	 */
	public List<Object[]> propertyStatistics(String name,String area,String seller,
	        String license,String use,String building,Date begin,Date end);
	
	public Pagination getPage(String name,String area,String seller,String license,
			 String use,String building,Date begin,Date end,int pageNo, int pageSize);
	//根据列获得去重复的值
	public List<String> getAllRow(String key);
}
